Vendor Document Data

Reports > Accounting > Vendor Document Data

The Financial Data Report presents detailed information on accounting.

1. Name - enter a report name
   Default: Vendor Document Data

2. Output - select output format
   Csv, Excel, Html, Json, or Pdf (default)
   Template (not pictured) - select a report template

3. Reset - click to reset to default options

4. Vendor Document Types - filter by document type (Bill, Credit Memo)

5. Expense Chart of Accounts - filter by expense account

6. Chart of Accounts - filter by account

7. Invoice Date - filter by invoice date

8. Vendor Document Statuses - filter by document status(es)

9. Asset Chart of Accounts - filter by asset account

10. Buildings - filter by building(s)

11. Due Date - filter by due date

 

12. Search - search for available columns
    Note: Columns are defined below

13. (+) - click or drag and drop to move available sort columns to the Selected Columns field

14. Drag and Drop to rearrange Selected Columns or click the Trash Can to remove a column from the selected columns field

15. Group By - choose one of the available column types to insert pages breaks at changes in value of the selected field

16. Include Total Row - check to include a total row at the bottom of the report

17. (+) - click or drag and drop to move available sort columns to the Sort By field
    Note: Columns selected in step 49 are available for sorting.

18. Drag and Drop to arrange Sort By columns in order of sort priority or click the Trash Can to remove a field

 

19. Paper Format - choose a paper format
    CR80
    Legal
    Letter (default)

20. Orientation - choose orientation
    Landscape
    Portrait (default)

21. Include Header - check to display report header on PDF or header row on CSV

22. Include Footer - check to display report footer on PDF

23. Include Filter - check to display selected filters on PDF

24. Save as Template - click to save the selected filters and columns as a template
    

1. Name - enter a template name

2. Public - check to make the template available to other users

3. Security Roles - select the security roles that can access a Public template

4. Cancel - click to return to the previous screen without saving the template

5. Save - click to save the template

25. Reset - click to reset to defaults

26. Request Report - click to request report
    Note: Report will appear in the bell icon when complete

Column Definitions

Column	Definition
Amount	Document Amount
Date	Document Date
Due Date	Document Due Date
Identifier	Vendor Document Identifier
Item Asset Chart of Account Name	Item Asset Chart of Account Name
Item Asset Chart of Account Number	Item Asset Chart of Account Number
Item Cost	Item Cost
Item Expense Chart of Account Name	Item Expense Chart of Account Name
Item Expense Chart of Account Number	Item Expense Chart of Account Number
Item Identifier	Item Identifier
Item Name	Item Name
Item Quantity	Item Quantity
Item Receipt Building Name	Item Receipt Building Name
Item Receipt Building Number	Item Receipt Building Number
Item Receipt Identifier	Item Receipt Identifier
Item Receipt Received Date	Item Receipt Received Date
Item Received Quantity	Item Received Quantity
Item Total	Item Total
Item Vendor Identifier	Item Vendor Identifier
Ledger Chart of Account Name	Ledger Chart of Account Name
Ledger Detail Amount	Ledger Detail Amount
Ledger Detail Building Name	Ledger Detail Building Name
Ledger Detail Building Number	Ledger Detail Building Number
Payment Term	Payment Term
Status	Status
Total Amount	Total Amount
Total Item Cost	Total Item Cost
Total Item Quantity	Total Item Quantity
Total Item Received Quantity	Total Item Quantity Received
Total Item Total	Total Item Total
Type	Type
Unique Identifier
Vendor Name	Vendor Name
Vendor Number	Vendor Number